package com.example.demo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.pojo.Stock.StockPositions;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface StockPositionsMapper extends BaseMapper<StockPositions> {
    @Update("UPDATE stock_positions SET available_quantity = available_quantity + frozen_quantity, frozen_quantity = 0;")
    void resetFrozenQuantity();

}
